home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 34.zip
/
BS1 part 34
/
Maxiplan III 3.5.adf
/
MP3
/
PlanHelp
/
commands.help
< prev
next >
Wrap
Text File
|
1990-01-05
|
5KB
|
115 lines
---------------------------------------------------------------------
COMMANDS MENU HELP
---------------------------------------------------------------------
The Commands Menu allows specific actions like movement of the
Active Cell
, calculation order, insertion or deletion of rows and
columns, filling in of data over selected ranges and Easy Sort.
---------------------------------------------------------------------
Select
---------------------------------------------------------------------
Use Select to reposition the worksheet at a specified location.
All Cells - selects all Cells between A1 and the rightmost,
bottommost cell containing data. The window is repositioned with
A1 in the upper left corner. Shift F9 key also performs this
Function.
Last Cell - selects the cell in the rightmost, bottommost position
which contains data, and positions that Cell in the upper left
corner of the window. Shift F10 key performs the same function.
Active Cell - positions the display so that the currently selected
Cell is in the upper left corner of the display.
Specify Location - displays a requester into which you can type
the Column/Row location of any cell in the worksheet. This
display will position with this cell in the top left corner.
Specify Name - displays the Name requester so you may select
a Cell location by Range Name.
---------------------------------------------------------------------
Calculate
---------------------------------------------------------------------
Dictates the timing of recalculations. Calculations can occur as:
Automatic - the entire Worksheet recalculates each time any Cell
is modified. Note: Only those cells which are
affected by the data you enter are actually
recalculated. This dramatically improves recalc
time compared to previous releases.
Manual - the Worksheet is recalculated only when the
Calculate Now Menu Item is selected.
Now - causes immediate recalculation when evoked.
Also accessed by: Right Amiga Key with =
F1 Function Key
--------------------------------------------------------------------
Cell Note
--------------------------------------------------------------------
Add is used to either specify or modify 5 lines of Text for a Cell
Note which may be either spoken, written or both.
Erase allows the deletion of an existing note.
--------------------------------------------------------------------
Insert/Delete
--------------------------------------------------------------------
Insert allows insertion of either one or a multiple of Rows and
Columns. Blank Rows are inserted above the Active Cell in any
Column while blank Columns are inserted to the left in Row.
Delete can remove either single or multiple selected Rows or Columns.
MaxiPlan will respond with a Requester asking you to confirm any
Row or Column deletions. Deletion will remove all data and formats
in the deleted Rows and Columns. Thus any Cell References to the
deleted Rows or Columns may result in an error in calculations.
--------------------------------------------------------------------
Fill
--------------------------------------------------------------------
Fill Down copies all information from the top Row of the selected
Range to all other Rows in the Range. Formulas containing Relative
Cell References are adjusted. Labels and values are simply copied.
Absolute Cell References may have to be adjusted.
Fill Down is also accessed by: Right Amiga Key with D
F7 Function Key
Fill Right copies all information from the left most Column of the
selected Range to all other Columns in the Range. Relative Cell
References, labels and values are handled as in Fill Down. Absolute
Cell References may have to be adjusted.
Fill Right is also accessed by: Right Amiga Key with R
F8 Function Key
--------------------------------------------------------------------
Read Range
--------------------------------------------------------------------
Amiga's voice will recite data entries in a selected Range.
Used to proof read data entries against a source document.
--------------------------------------------------------------------
Easy Sort
--------------------------------------------------------------------
This is used to sort the Rows of a selected Range based on the
contents in the Cells of the first left most Column of the selected
Range. Easy Sort can also be accessed by F6 with Shift Key.